<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@ page import="elibrary.*" %>
<%@ page language="java" import="java.util.*"%>
<%@ include file="config.jsp" %>

<%!int count=0; %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>My-Library | Add Books</title>
        <meta name="keywords" content="My Library" />
        <meta name="description" content="Library" />
        <link href="css/style.css" rel="stylesheet" type="text/css" />
        <link href="css/jquery.ennui.contentslider.css" rel="stylesheet" type="text/css" media="screen,projection" />
        <script language="javascript" type="text/javascript">

            //Function to clear the contents of field on by clicking on the field

            function clearText(field)
            {
                if (field.defaultValue == field.value) field.value = '';
                else if (field.value == '') field.value = field.defaultValue;
            }
        </script>
    </head>
    <body>
        <div id="templatemo_header_wrapper">

            <div id="templatemo_header">

                <div id="site_logo"><img src="images/logo.jpeg" width="100" height="100"/></div><div align="left"><img src="images/header.png"/></div>
            </div> <!-- end of header -->
        </div> <!-- end of header wrapper -->

        <div id="templatemo_menu_wrapper">

            <div id="templatemo_menu">
                <ul>
                    <li><a href="#" class="current">Home</a></li>
                    <li><a href="#">Web Design</a></li>
                    <li><a href="http://www.templatemo.com" target="_parent">Templates</a></li>
                    <li><a href="#">About</a></li>
                    <li><a href="#" class="last">Contact Us</a></li>
                </ul>
            </div> <!-- end of menu -->
        </div> <!-- end of menu wrapper -->

        <div id="tempatemo_content_wrapper">

            <div id="templatemo_content">

                <div id="content_panel">
                    <form action="admin_viewrequestsprocess.jsp">
                        <div id="column_w610" height:400px;>

                             <div class="header_01" align="left">
                                <p><i>
           	      Welcome .........,</i>  </p>
                            </div>
                            <div class="header_05" align="left">
                                <u>View Requests</u>
                            </div>
                            <br>
                                <div class="section_01">
                                    <table class="tab1" border=1>
                                        <tr><td align="center">Select</td><td align="center">Book Name</td><td align="center">Author</td><td align="center">Publisher</td><td align="center">Category</td></tr>
                                        <%
                                        // User is checked whether he is an administrator; if yes, he is allowed to view requests
                                        try{
                                                String uid = (String) session.getAttribute("uid");
                                                if(uid==null)
                                                {
                                                        response.sendRedirect("index.jsp");
                                                }
                                                int type=Integer.parseInt((String)session.getAttribute("type"));
                                            if(type!=3)
                                            {
                                                 response.sendRedirect("home.jsp");
                                            }
			
                                                        DesEncrypter encrypter = new DesEncrypter();
                                                        int uid1 = Integer.parseInt(encrypter.decrypt(uid));
				
                        // Connection is made to the database and all the requests are dispalyed

                    Connection c=DaoConnection.getcon(connectURL, DBuser, DBpass);
                    Statement st=c.createStatement();
                    ResultSet rs=st.executeQuery("SELECT * FROM REQUEST");
                    count=0;
                while(rs.next())
                {count++;
                                        %>


                                        <tr><td align="center"><input type="checkbox" name="id" value="<%=rs.getString(1) %>"></td><td align="center"><%=rs.getString(1) %></td><td align="center"><%=rs.getString(2) %></td><td align="center"><%=rs.getString(3) %></td><td align="center"><%=rs.getString(4) %></td></tr>
                                        <% }}catch(Exception e){e.printStackTrace();}%>

                                    </table>

                                    <%
          
                                    for(int x=0;x<count;x++){ %>
                                    <br /><br /><%} %>
                                </div>
                                <center><div>		 &nbsp; &nbsp;<input type="submit" name="res" value="ORDER"> &nbsp; &nbsp;<input type="submit" name="res" value="REJECT"></div></center>
                                                <ul class="list_with_icon">

                                                    <li>Last Login : ...............</li>
                                                </ul>
                                                </div> </form><!-- end of column w610 -->

                                                <div id="column_w290">

                                                    <div class="header_02">Choose from here </div>

                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50"> </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left">
                                                                <p><a href="#">Users Details</a></p>
                                                            </div>
                                                        </div>

                                                        <div class="cleaner"></div>
                                                    </div>

                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">                        </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left"><a href="#">View Requests</a></div>
                                                        </div>

                                                        <div class="cleaner"></div>
                                                    </div>

                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">                        </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left"><a href="#">Browse Books</a></div>
                                                        </div>

                                                        <div class="cleaner"></div>
                                                    </div>

                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">                        </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left"><a href="#">Add New Books</a></div>
                                                        </div>


                                                        <div class="cleaner"></div>
                                                    </div>
                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">                        </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left"><a href="#">View logs</a></div>
                                                        </div>

                                                        <div class="cleaner"></div>
                                                    </div>
                                                    <div class="choose_options">
                                                        <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">                        </div>
                                                        <div class="opt_content">
                                                            <div class="header_05" align="left"><a href="#">Generate Reports</a></div>
                                                        </div>

                                                        <div class="cleaner"></div>
                                                    </div>
                                                </div> <!-- end of column 290 -->

                                                <div class="cleaner"></div>
                                                </div> <!-- end of content panel -->

                                                <div class="cleaner"></div>
                                                </div> <!-- end of content -->
                                                </div> <!-- end of content wrapper -->

                                                <div id="templatemo_footer_wrapper">

                                                    <div id="templatemo_footer">

                                                        <center>Copyright &#169; 2010 MyLibrary &nbsp &nbsp | &nbsp &nbsp <a href="termsandconditions.jsp"><font color="#828c96"> Terms and Conditions</font></a> </center><br></br>
                                                        <center><b>Disclaimer:</b> No Part of this site can be copied or reproduced in any form, excepting for personal information, without the written permission of the owners.</center>
                                                    </div> <!-- end of footer -->
                                                </div> <!-- end of footer -->
                                                </body>
                                                </html>

